﻿CREATE TABLE [dbo].[ConsumableList] (
    [id]                 INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [ConsumableName]     NVARCHAR (100) NULL,
    [ConsumableAllMonth] INT            NULL,
    [userid]             VARCHAR (20)   NULL,
    [username]           NVARCHAR (20)  NULL,
    [lrDate]             DATETIME       NULL,
    CONSTRAINT [PK_Loss_Product] PRIMARY KEY CLUSTERED ([id] ASC)
);

